<template>
  <div>
    <div class="gva-search-box">
      <el-form :inline="true" :model="searchInfo" class="demo-form-inline" @keyup.enter="onSubmit">
        <el-form-item label="创建时间">
          <el-date-picker v-model="searchInfo.startCreatedAt" type="datetime" placeholder="开始时间" />
          —
          <el-date-picker v-model="searchInfo.endCreatedAt" type="datetime" placeholder="结束时间" />
        </el-form-item>
        <el-form-item>
          <el-button type="primary" icon="search" @click="onSubmit">查询</el-button>
          <el-button icon="refresh" @click="onReset">重置</el-button>
        </el-form-item>
      </el-form>
    </div>
    <div class="gva-table-box">
      <el-table
        ref="multipleTable"
        style="width: 100%"
        tooltip-effect="dark"
        :data="tableData"
        row-key="ID"
        size="small"
        border
        :cell-style="{padding:'0px'}"
        :header-cell-style="{background:'#a3c6d2',color:'#849ba1',padding:'0px'}"
        @selection-change="handleSelectionChange"
      >
        <el-table-column align="left" label="源库id" prop="odbId" width="60" />
        <el-table-column align="left" label="源库名" prop="odbSchema" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="源表名" prop="odbTbName" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="源列名" prop="colName" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="源列类型" prop="colType" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="源数据类型" prop="dataType" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="源数据长度" prop="dataLength" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="源列注释" prop="colComment" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="是否主键" prop="colKey" width="80" />
        <el-table-column align="left" label="ods库名" prop="odsSchemaName" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="ods表名" prop="odsTbName" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="ods列名" prop="odsColName" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="ods列类型" prop="odsColType" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="ods数据类型" prop="odsDataType" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="ods数据长度" prop="odsDataLength" :show-overflow-tooltip="true"/>
        <el-table-column align="left" label="ods注释" prop="odsColComment" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="列转换" prop="colConv" width="80" />
        <el-table-column align="left" label="操作" width="80">
          <template #default="scope">
            <el-button type="primary" link icon="edit" class="table-button" @click="updateOdsDbFieldFunc(scope.row)">变更</el-button>
          </template>
        </el-table-column>
      </el-table>
      <div class="gva-pagination">
        <el-pagination
          layout="total, sizes, prev, pager, next, jumper"
          :current-page="page"
          :page-size="pageSize"
          :page-sizes="[10, 30, 50, 100]"
          :total="total"
          @current-change="handleCurrentChange"
          @size-change="handleSizeChange"
        />
      </div>
    </div>
    <el-dialog v-model="dialogFormVisible" :before-close="closeDialog" title="弹窗操作" class="dialog-mid">
      <el-form
        ref="elFormRef"
        class="x-form"
        :model="formData"
        label-position="right"
        :rules="rule"
        :inline="true"
      >
        <el-form-item label="源表id:" prop="odsDbTbId">
          <el-input v-model="formData.odsDbTbId" :disabled="true" />
        </el-form-item>
        <el-form-item label="源模式名:" prop="srcSchemaName">
          <el-input v-model="formData.srcSchemaName" :disabled="true" />
        </el-form-item>
        <el-form-item label="源表名:" prop="srcTblName">
          <el-input v-model="formData.srcTblName" :disabled="true" />
        </el-form-item>
        <el-form-item label="列名:" prop="colName">
          <el-input v-model="formData.colName" :disabled="true" />
        </el-form-item>
        <el-form-item label="列类型:" prop="colType">
          <el-input v-model="formData.colType" :disabled="true" />
        </el-form-item>
        <el-form-item label="ods库名:" prop="odsSchemaName">
          <el-input v-model="formData.odsSchemaName" :disabled="true" />
        </el-form-item>
        <el-form-item label="ods表名:" prop="odsTbName">
          <el-input v-model="formData.odsTbName" disabled />
        </el-form-item>
        <el-form-item label="ods列名:" prop="odsColName">
          <el-input v-model="formData.odsColName" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="ods列类型:" prop="odsColType">
          <el-input v-model="formData.odsColType" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="ods字段注释:" prop="odsColComment">
          <el-input v-model="formData.odsColComment" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="ods列标签:" prop="odsLabel">
          <el-input v-model="formData.odsLabel" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="是否唯一:" prop="unique">
          <el-input v-model="formData.colKey" placeholder="请输入" />
        </el-form-item>
      </el-form>
      <template #footer>
        <div class="dialog-footer">
          <el-button @click="closeDialog">取 消</el-button>
          <el-button type="primary" @click="enterDialog">确 定</el-button>
        </div>
      </template>
    </el-dialog>
  </div>
</template>

<script>
export default {
  name: 'OdsDbField'
}
</script>

<script setup>
import {
  createOdsDbField,
  deleteOdsDbField,
  deleteOdsDbFieldByIds,
  updateOdsDbField,
  findOdsDbField,
  getOdsDbFieldList
} from '@/api/odsDbField'

import { ElMessage, ElMessageBox } from 'element-plus'
import { ref, reactive } from 'vue'

const formData = ref({
  odsDbTbId: '',
  srcSchemaName: '',
  srcTblName: '',
  colName: '',
  colType: '',
  colComment: '',
  colKey: '',
  odsSchemaName: '',
  odsTbName: '',
  odsColName: '',
  odsColType: '',
  odsColComment: '',
  odsLabel: '',
  unique: '',
})

const rule = reactive({})

const elFormRef = ref()

const page = ref(1)
const total = ref(0)
const pageSize = ref(10)
const tableData = ref([])
const searchInfo = ref({})

const onReset = () => {
  searchInfo.value = {}
  getTableData()
}

const onSubmit = () => {
  page.value = 1
  pageSize.value = 10
  getTableData()
}

const handleSizeChange = (val) => {
  pageSize.value = val
  getTableData()
}

const handleCurrentChange = (val) => {
  page.value = val
  getTableData()
}

const getTableData = async() => {
  const table = await getOdsDbFieldList({ page: page.value, pageSize: pageSize.value, ...searchInfo.value })
  if (table.code === 0) {
    tableData.value = table.data.list
    total.value = table.data.total
    page.value = table.data.page
    pageSize.value = table.data.pageSize
  }
}

getTableData()


const setOptions = async() => {
}

setOptions()

const multipleSelection = ref([])
const handleSelectionChange = (val) => {
  multipleSelection.value = val
}

const deleteRow = (row) => {
  ElMessageBox.confirm('确定要删除吗?', '提示', {
    confirmButtonText: '确定',
    cancelButtonText: '取消',
    type: 'warning'
  }).then(() => {
    deleteOdsDbFieldFunc(row)
  })
}

const deleteVisible = ref(false)

const deleteSelectedRow = async() => {
  const ids = []
  if (multipleSelection.value.length === 0) {
    ElMessage({
      type: 'warning',
      message: '请选择要删除的数据'
    })
    return
  }
  multipleSelection.value &&
  multipleSelection.value.map(item => {
    ids.push(item.ID)
  })
  const res = await deleteOdsDbFieldByIds({ ids })
  if (res.code === 0) {
    ElMessage({
      type: 'success',
      message: '删除成功'
    })
    if (tableData.value.length === ids.length && page.value > 1) {
      page.value--
    }
    deleteVisible.value = false
    getTableData()
  }
}

const type = ref('')

const updateOdsDbFieldFunc = async(row) => {
  const res = await findOdsDbField({ ID: row.ID })
  type.value = 'update'
  if (res.code === 0) {
    formData.value = res.data.reodsDbField
    dialogFormVisible.value = true
  }
}

const deleteOdsDbFieldFunc = async(row) => {
  const res = await deleteOdsDbField({ ID: row.ID })
  if (res.code === 0) {
    ElMessage({
      type: 'success',
      message: '删除成功'
    })
    if (tableData.value.length === 1 && page.value > 1) {
      page.value--
    }
    getTableData()
  }
}

const dialogFormVisible = ref(false)

const openDialog = () => {
  type.value = 'create'
  dialogFormVisible.value = true
}

const closeDialog = () => {
  dialogFormVisible.value = false
  formData.value = {
    dbId: '',
    dbType: '',
    schemaId: '',
    schemaName: '',
    tbId: '',
    tblName: '',
    ipSchemaTb: '',
    ipSchemaTbFld: '',
    charSet: '',
    colName: '',
    colComment: '',
    colKey: '',
    colType: '',
    dataType: '',
    foreignKey: '',
    index: '',
    isNull: '',
    maxLength: 0,
    odsColName: '',
    odsColComment: '',
    odsColType: '',
    odsDataType: '',
    odsLabel: '',
    remarks: '',
    sync: 0,
    timeFormat: '',
    unique: '',
  }
}
const enterDialog = async() => {
  elFormRef.value?.validate(async(valid) => {
    if (!valid) return
    let res
    switch (type.value) {
      case 'create':
        res = await createOdsDbField(formData.value)
        break
      case 'update':
        res = await updateOdsDbField(formData.value)
        break
      default:
        res = await createOdsDbField(formData.value)
        break
    }
    if (res.code === 0) {
      ElMessage({
        type: 'success',
        message: '创建/更改成功'
      })
      closeDialog()
      getTableData()
    }
  })
}
</script>

<style>
</style>
